1. Select Tools > Intelligent Query Architect> New > Query.
2. Mode: Basic
3. On the Summary tab, enter the name and description for this query.
4. On the Sources tab, add the sources Common> Business Objects> CsContact and Common> Business Objects> Activity.
5. Use the default relation between the two business objects:
FK_ Name_Activity (When CsContact.ImisId = Activity.Id)
6. On the Filters tab, select:
Where
StateProvince Equal New York
CsContact.MemberType Equal Member
Activity.ActivityType Equal MEETING
Activity.TransactionDate Greater Equal 1/1/2009
7. On the Display tab, View > Selected columns. Select the columns to display and the order. Select the Only display unique results option.
8. Click Run. The results are a subset of the list in the previous example:
Example query results: Members from New York who attended the 2009 Conference